<?xml version="1.0" encoding="UTF-8"?>
<dxl:DXLMessage xmlns:dxl="http://greenplum.com/dxl/2010/12/">
  <dxl:Plan>
    <dxl:GatherMotion InputSegments="0,1" OutputSegments="-1">
      <dxl:Properties>
        <dxl:Cost StartupCost="10" TotalCost="100" Rows="1" Width="8"/>
      </dxl:Properties>
      <dxl:ProjList>
        <dxl:ProjElem ColId="1" Alias="foo.b">
          <dxl:Ident ColId="1" ColName="foo.b" TypeMdid="0.23.1.0"/>
        </dxl:ProjElem>
      </dxl:ProjList>
      <dxl:Filter/>
      <dxl:SortingColumnList/>
      <dxl:Aggregate AggregationStrategy="Hashed" StreamSafe="false">
        <dxl:Properties>
          <dxl:Cost StartupCost="10" TotalCost="100" Rows="1" Width="8"/>
        </dxl:Properties>
        <dxl:GroupingColumns>
          <dxl:GroupingColumn ColId="1"/>
        </dxl:GroupingColumns>
        <dxl:ProjList>
          <dxl:ProjElem ColId="1" Alias="foo.b">
            <dxl:Ident ColId="1" ColName="foo.b" TypeMdid="0.23.1.0"/>
          </dxl:ProjElem>
        </dxl:ProjList>
        <dxl:Filter/>
        <dxl:RedistributeMotion InputSegments="0,1" OutputSegments="0,1">
          <dxl:Properties>
            <dxl:Cost StartupCost="10" TotalCost="100" Rows="1" Width="8"/>
          </dxl:Properties>
          <dxl:ProjList>
            <dxl:ProjElem ColId="1" Alias="foo.b">
              <dxl:Ident ColId="1" ColName="foo.b" TypeMdid="0.23.1.0"/>
            </dxl:ProjElem>
          </dxl:ProjList>
          <dxl:Filter/>
          <dxl:SortingColumnList/>
          <dxl:HashExprList>
            <dxl:HashExpr>
              <dxl:Ident ColId="1" ColName="foo.b" TypeMdid="0.23.1.0"/>
            </dxl:HashExpr>
          </dxl:HashExprList>
          <dxl:Aggregate AggregationStrategy="Hashed" StreamSafe="false">
            <dxl:Properties>
              <dxl:Cost StartupCost="10" TotalCost="100" Rows="1" Width="8"/>
            </dxl:Properties>
            <dxl:GroupingColumns>
              <dxl:GroupingColumn ColId="1"/>
            </dxl:GroupingColumns>
            <dxl:ProjList>
              <dxl:ProjElem ColId="1" Alias="foo.b">
                <dxl:Ident ColId="1" ColName="foo.b" TypeMdid="0.23.1.0"/>
              </dxl:ProjElem>
            </dxl:ProjList>
            <dxl:Filter/>
            <dxl:NestedLoopJoin JoinType="In">
              <dxl:Properties>
                <dxl:Cost StartupCost="10" TotalCost="100" Rows="8" Width="8"/>
              </dxl:Properties>
              <dxl:ProjList>
                <dxl:ProjElem ColId="1" Alias="foo.b">
                  <dxl:Ident ColId="1" ColName="foo.b" TypeMdid="0.23.1.0"/>
                </dxl:ProjElem>
              </dxl:ProjList>
              <dxl:Filter/>
              <dxl:JoinFilter>
                <dxl:Not>
                  <dxl:IsDistinctFrom OperatorMdid="0.96.1.0">
                    <dxl:Ident ColId="1" ColName="foo.b" TypeMdid="0.23.1.0"/>
                    <dxl:Ident ColId="11" ColName="r.b" TypeMdid="0.23.1.0"/>
                  </dxl:IsDistinctFrom>
                </dxl:Not>
              </dxl:JoinFilter>
              <dxl:TableScan>
                <dxl:Properties>
                  <dxl:Cost StartupCost="10" TotalCost="100" Rows="8" Width="8"/>
                </dxl:Properties>
                <dxl:ProjList>
                  <dxl:ProjElem ColId="1" Alias="foo.b">
                    <dxl:Ident ColId="1" ColName="foo.b" TypeMdid="0.23.1.0"/>
                  </dxl:ProjElem>
                </dxl:ProjList>
                <dxl:Filter/>
                <dxl:TableDescriptor Mdid="6.17026.1.1" TableName="foo">
                  <dxl:Columns>
                    <dxl:Column ColId="0" Attno="1" ColName="a" TypeMdid="0.23.1.0"/>
                    <dxl:Column ColId="1" Attno="2" ColName="b" TypeMdid="0.23.1.0"/>
                    <dxl:Column ColId="2" Attno="3" ColName="c" TypeMdid="0.23.1.0"/>
                    <dxl:Column ColId="3" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/>
                    <dxl:Column ColId="4" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/>
                    <dxl:Column ColId="5" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/>
                    <dxl:Column ColId="6" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/>
                    <dxl:Column ColId="7" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/>
                    <dxl:Column ColId="8" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/>
                    <dxl:Column ColId="9" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/>
                  </dxl:Columns>
                </dxl:TableDescriptor>
              </dxl:TableScan>
              <dxl:Materialize Eager="false">
                <dxl:Properties>
                  <dxl:Cost StartupCost="10" TotalCost="100" Rows="8" Width="8"/>
                </dxl:Properties>
                <dxl:ProjList>
                  <dxl:ProjElem ColId="11" Alias="r.b">
                    <dxl:Ident ColId="11" ColName="r.b" TypeMdid="0.23.1.0"/>
                  </dxl:ProjElem>
                </dxl:ProjList>
                <dxl:Filter/>
                <dxl:BroadcastMotion InputSegments="0,1" OutputSegments="0,1">
                  <dxl:Properties>
                    <dxl:Cost StartupCost="10" TotalCost="100" Rows="8" Width="8"/>
                  </dxl:Properties>
                  <dxl:ProjList>
                    <dxl:ProjElem ColId="11" Alias="r.b">
                      <dxl:Ident ColId="11" ColName="r.b" TypeMdid="0.23.1.0"/>
                    </dxl:ProjElem>
                  </dxl:ProjList>
                  <dxl:Filter/>
                  <dxl:SortingColumnList/>
                  <dxl:TableScan>
                    <dxl:Properties>
                      <dxl:Cost StartupCost="10" TotalCost="100" Rows="8" Width="8"/>
                    </dxl:Properties>
                    <dxl:ProjList>
                      <dxl:ProjElem ColId="11" Alias="r.b">
                        <dxl:Ident ColId="11" ColName="r.b" TypeMdid="0.23.1.0"/>
                      </dxl:ProjElem>
                    </dxl:ProjList>
                    <dxl:Filter/>
                    <dxl:TableDescriptor Mdid="6.17539.1.1" TableName="r">
                      <dxl:Columns>
                        <dxl:Column ColId="10" Attno="1" ColName="a" TypeMdid="0.23.1.0"/>
                        <dxl:Column ColId="11" Attno="2" ColName="b" TypeMdid="0.23.1.0"/>
                        <dxl:Column ColId="12" Attno="-1" ColName="ctid" TypeMdid="0.27.1.0"/>
                        <dxl:Column ColId="13" Attno="-3" ColName="xmin" TypeMdid="0.28.1.0"/>
                        <dxl:Column ColId="14" Attno="-4" ColName="cmin" TypeMdid="0.29.1.0"/>
                        <dxl:Column ColId="15" Attno="-5" ColName="xmax" TypeMdid="0.28.1.0"/>
                        <dxl:Column ColId="16" Attno="-6" ColName="cmax" TypeMdid="0.29.1.0"/>
                        <dxl:Column ColId="17" Attno="-7" ColName="tableoid" TypeMdid="0.26.1.0"/>
                        <dxl:Column ColId="18" Attno="-8" ColName="gp_segment_id" TypeMdid="0.23.1.0"/>
                      </dxl:Columns>
                    </dxl:TableDescriptor>
                  </dxl:TableScan>
                </dxl:BroadcastMotion>
              </dxl:Materialize>
            </dxl:NestedLoopJoin>
          </dxl:Aggregate>
        </dxl:RedistributeMotion>
      </dxl:Aggregate>
    </dxl:GatherMotion>
  </dxl:Plan>
</dxl:DXLMessage>
